|
Oracle Database 12c Release 2 : Add Net Listener
2015/07/05 |
|
Add Oracle Net Listener that is the network service on Oracle.
|
|
| [1] | Login with the oracle admin user and input a command [netca] like follows. |
|
[oracle@dlp ~]$ netca
|
| [2] | Check a box [Listener Configuration] and go next. |
|
| [3] | Go next. |
|
| [4] | Set Listner's name. Set any name you like. |
|
| [5] | This example goes next with keeping default [TCP]. |
|
| [6] | Set a port. This example goes next with keeping default. |
|
| [7] | If you'd like to create more Listeners, Answer [Yes]. This example selects [No]. |
|
| [8] | Configuration completed. |
|
| [9] | After creating Listener, tnslsnr listens on the port you configured like follows. |
|
[oracle@dlp ~]$ ss -napt
State Recv-Q Send-Q Local Address:Port Peer Address:Port
LISTEN 0 128 *:111 *:*
LISTEN 0 128 *:6000 *:*
LISTEN 0 5 192.168.122.1:53 *:*
LISTEN 0 128 *:22 *:*
LISTEN 0 128 127.0.0.1:631 *:*
LISTEN 0 100 127.0.0.1:25 *:*
LISTEN 0 128 :::111 :::*
LISTEN 0 128 :::6000 :::*
LISTEN 0 128 :::1521 :::* users:(("tnslsnr",pid=13444,fd=8))
LISTEN 0 5 ::ffff:127.0.0.1:33622 :::*
LISTEN 0 128 :::22 :::*
LISTEN 0 128 ::1:631 :::*
LISTEN 0 100 ::1:25 :::*
LISTEN 0 5 ::ffff:127.0.0.1:34633 :::*
[oracle@dlp ~]$ tnsping localhost
TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 13-OCT-2017 11:13:38
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))
(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (10 msec)
|
| [10] | If Firewalld is running, allow listener port. |
|
[root@dlp ~]# firewall-cmd --add-port=1521/tcp --permanent success [root@dlp ~]# firewall-cmd --reload success |